CREATE TABLE x_d_nginx(
    ts_iso          STRING,
    version         STRING,
    remote_addr     STRING,
    remote_user     STRING,
    server_name     STRING,
    request         STRING,
    traceID         STRING,
    groupID         STRING,
    status          STRING,
    bytes           STRING,
    referer         STRING,
    agent           STRING,
    verb            STRING,
    x_forwarded     STRING,
    request_time    STRING,
    upstream_addr   STRING,
    ups_resp_time   STRING
)PARTITIONED BY (ds STRING, app STRING)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' COLLECTION ITEMS TERMINATED BY ','
LINES TERMINATED BY '\n' STORED AS TEXTFILE LOCATION '/user/hive/warehouse/x_d_nginx';
